Enables you to find the standard deviation of a set of values in your report. For example:
The following examples are applicable to both Basic and Crystal syntax:
Calculates the standard deviation of all values in the Result field.
StdDev({orders.AMOUNT}, {orders.CUSTOMER ID})
Calculates the standard deviation for the orders in each group of orders in the Orders field. The orders are separated into groups whenever the value in the Customer field changes.
StdDev({file.RESULTS}, {file.DATE}, "daily")
Calculates the variation for each group of laboratory test results in the Results field. The test results are separated into groups whenever the value in the Date field changes to a new day.
StdDev({file.SCORES}, {file.NATURALIZED}, "any change")
Groups values in the Scores field based on whether or not the test taker is a naturalized citizen, and calculates the standard deviation for each group of scores.
The following example is applicable to Crystal syntax:
StdDev([({file.QTY1} * {file.PRICE1}),({file.QTY2} * {file.PRICE2}),({file.QTY3} * {file.PRICE3}), ({file.QTY4} * {file.PRICE4})])
Returns 36.60 where Qty1 = 2, Price1 = 10.00, Qty2 = 2, Price2 = 2.00, Qty3 = 10, Price3 = 3.00, and Qty4 = 8, Price4 = 11.00.
Standard deviation is calculated using the following technique:
Note: Using this function in a formula forces the formula to be evaluated at print time.
For more information on evaluation time considerations, see Evaluation Time functions.
Seagate Software IMG Holdings, Inc. http://www.seagatesoftware.com Support services: http://support.seagatesoftware.com |